{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Reference Range Establishment"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Reference Range Establishment","index":0,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,5,43,6],[7,0,7,2],[28,0,28,1],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[43,2,43,4]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 502 (version 1.0). Reference Range Establishment (ALT)_Example. Page 1 of 1"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"Vitros 250",{"$nulls":4},"Date:","2023-08-03"]
[null,"Analyte",null,"ALT"]
["Reference Range:",null,null,{"$f":"IFERROR(K23,\"\")","v":4},"to",{"$f":"IFERROR(J34,\"\")","v":36},null,"Units:","U/L"]
[]
[{"$nulls":8},130]
[]
[5,8,15,30,22,9,12,6,12,6,9,5]
[5,6,25,8,36,30,30,6,22,6,12,6]
[10,6,30,6,22,8,8,6,33,9,4,9]
[8,9,8,6,33,6,6,9,36,9,22,9]
[6,9,6,9,36,6,6,12,6,12,21,12]
[6,12,6,9,5,9,9,4,9,6,12,6]
[9,4,9,12,6,9,9,22,9,9,4,9]
[9,22,9,4,9,12,12,21,12,9,22,9]
[12,21,12,25,11,4,25,18,12,12,21,12]
[4,16,4,9,12,6,27,32,4,95,52,36]
[]
["Mean: ",null,{"$f":"IFERROR(MROUND(AVERAGE(A12:L21),0.01),\"---\")","v":13.5},{"$nulls":5},"Low",null,{"$f":"SMALL(A12:L21,3)","v":4},{"$f":"K23-0.01","v":3.9900000000000002}]
["SD: ",null,{"$f":"IFERROR(MROUND(STDEV(A12:L21),0.01),\"---\")","v":11.9},{"$nulls":5},"High",null,{"$f":"SMALL(A12:L21,118)","v":36},{"$f":"K24+0.01","v":36.009999999999998}]
["Minimum: ",null,{"$f":"MIN(A12:L21)","v":4},{"$nulls":5},"Bin1",{"$f":"L23","v":3.9900000000000002},{"$f":"K24-K23","v":32}]
["Maximum: ",null,{"$f":"MAX(A12:L21)","v":95},{"$nulls":5},"Bin2",{"$f":"MROUND(J25+(0.2*K25),0.01)","v":10.390000000000001}]
["Median: ",null,{"$f":"IFERROR(MEDIAN(A12:L21),\"---\")","v":9},{"$nulls":5},"Bin3",{"$f":"MROUND($J$25+(0.3*$K$25),0.01)","v":13.59}]
[{"$nulls":8},"Bin4",{"$f":"MROUND($J$25+(0.4*$K$25),0.01)","v":16.789999999999999}]
[{"$f":"I8","v":"U/L"},null,"Frequency","Percent",{"$nulls":4},"Bin5",{"$f":"MROUND($J$25+(0.5*$K$25),0.01)","v":19.990000000000002}]
[{"$f":"\"≤\"&\" \"&J25","v":"≤ 3.99"},null,{"$f":"FREQUENCY(A12:L21,J25:J34)","v":0},{"$f":"C30/120","v":0},{"$nulls":4},"Bin6",{"$f":"MROUND($J$25+(0.6*$K$25),0.01)","v":23.190000000000001}]
[{"$f":"(J25+0.01)&\" \"&\"-\"&\" \"&J26","v":"4 - 10.39"},null,70,{"$f":"C31/120","v":0.58333333333333337},{"$nulls":4},"Bin7",{"$f":"MROUND($J$25+(0.7*$K$25),0.01)","v":26.390000000000001}]
[{"$f":"(J26+0.01)&\" \"&\"-\"&\" \"&J27","v":"10.4 - 13.59"},null,19,{"$f":"C32/120","v":0.15833333333333333},{"$nulls":4},"Bin8",{"$f":"MROUND($J$25+(0.8*$K$25),0.01)","v":29.59}]
[{"$f":"(J27+0.01)&\" \"&\"-\"&\" \"&J28","v":"13.6 - 16.79"},null,2,{"$f":"C33/120","v":0.016666666666666666},{"$nulls":4},"Bin9",{"$f":"MROUND($J$25+(0.9*$K$25),0.01)","v":32.789999999999999}]
[{"$f":"(J28+0.01)&\" \"&\"-\"&\" \"&J29","v":"16.8 - 19.99"},null,1,{"$f":"C34/120","v":0.0083333333333333332},{"$nulls":4},"Bin10",{"$f":"K24","v":36}]
[{"$f":"(J29+0.01)&\" \"&\"-\"&\" \"&J30","v":"20 - 23.19"},null,11,{"$f":"C35/120","v":0.09166666666666666}]
[{"$f":"(J30+0.01)&\" \"&\"-\"&\" \"&J31","v":"23.2 - 26.39"},null,3,{"$f":"C36/120","v":0.025000000000000001},null,null,null,"CI-L",{"$f":"SMALL(A12:L21,1)","v":4},{"$f":"SMALL(A12:L21,7)","v":4}]
[{"$f":"(J31+0.01)&\" \"&\"-\"&\" \"&J32","v":"26.4 - 29.59"},null,1,{"$f":"C37/120","v":0.0083333333333333332},null,null,null,"CI-U",{"$f":"SMALL(A12:L21,114)","v":33},{"$f":"SMALL(A12:L21,120)","v":95}]
[{"$f":"(J32+0.01)&\" \"&\"-\"&\" \"&J33","v":"29.6 - 32.79"},null,5,{"$f":"C38/120","v":0.041666666666666664},null,null,null,"CR",{"$f":"0.5*(J37-I37+J36-I36)/(K24-K23)","v":0.96875}]
[{"$f":"(J33+0.01)&\" \"&\"-\"&\" \"&J34","v":"32.8 - 36"},null,6,{"$f":"C39/120","v":0.050000000000000003}]
[{"$f":"\">\"&\" \"&J34","v":"> 36"},null,2,{"$f":"C40/120","v":0.016666666666666666}]
[]
[]
[]
[null,null,"Confidence Intervals"]
[null,"Lower",{"$f":"I36","v":4},"to",{"$f":"J36","v":4}]
[null,"Upper",{"$f":"I37","v":33},"to",{"$f":"J37","v":95}]